www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/admin/db/ChangeField.php
<?php
define('EmpireCMSAdmin','1');
require("../../class/connect.php");
require("../../class/db_sql.php");
require("../../class/functions.php");
require "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
//驗證用戶
$lur=is_login();
$logininid=$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
$tid=(int)$_GET['tid'];
if($tid)
{
$tbwhere="tid='$tid'";
$search="&tid=$tid";
}
else
{
$tbname=RepPostVar($_GET['tbname']);
$tbwhere="tbname='$tbname'";
$search="&tbname=$tbname";
}
$viewf=RepPostVar($_GET['viewf']);
$changef=RepPostVar($_GET['changef']);
if(!$viewf||!$changef)
{
printerror('ErrorUrl','');
}
//取得表名
$tbr=$empire->fetch1("select tbname from {$dbtbpre}enewstable where ".$tbwhere);
if(!$tbr['tbname'])
{
printerror('ErrorUrl','');
}
$tbname=$tbr['tbname'];
//字段
$sysf=',id,classid,onclick,newspath,keyboard,keyid,userid,username,ztid,checked,istop,truetime,ismember,dokey,userfen,isgood,titlefont,titleurl,filename,groupid,newstempid,plnum,firsttitle,isqf,totaldown,closepl,havehtml,lastdotime,haveaddfen,infopfen,infopfennum,votenum,stb,ttid,infotags,';
$viewfr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$viewf' and tbdataf=0 limit 1");
$changefr=$empire->fetch1("select f,fname from {$dbtbpre}enewsf where ".$tbwhere." and f='$changef' and tbdataf=0 limit 1");
if(!$viewfr[f]&&!strstr($sysf,','.$viewf.','))
{
printerror('ErrorUrl','');
}
if(!$changefr[f]&&!strstr($sysf,','.$changef.','))
{
printerror('ErrorUrl','');
}
if(strstr($sysf,','.$viewf.','))
{
$viewfr[fname]=$viewf;
}
if(strstr($sysf,','.$changef.','))
{
$changefr[fname]=$changef;
}
$form=$_GET['form'];
if(empty($form))
{
$form='add';
}
$field=$_GET['field'];
$add='';
//關鍵字
$keyboard=RepPostVar2($_GET['keyboard']);
if(!empty($keyboard))
{
$show=RepPostVar($_GET['show']);
if($show==$viewf||$show==$changef)
{
$add=" where ".$show." like '%".$keyboard."%'";
}
if($show==$changef)
{
$searchoptionselect=' selected';
}
}
$changeline=(int)$_GET['changeline'];
if(empty($changeline))
{
$changeline=2;
}
$search.="&viewf=$viewf&changef=$changef&form=$form&field=$field&show=$show&keyboard=$keyboard&changeline=$changeline";
if($viewf==$changef)
{
$searchoption="<option value='$viewf'>$viewfr[fname]</option>";
}
else
{
$searchoption="<option value='$viewf'>$viewfr[fname]</option><option value='$changef'".$searchoptionselect.">$changefr[fname]</option>";
}
//分頁
$page=(int)$_GET['page'];
$start=0;
$line=50;//每頁顯示條數
$page_line=12;//每頁顯示鏈接數
$offset=$page*$line;//總偏移量
$query="select ".$viewf.",".$changef." from {$dbtbpre}ecms_".$tbname.$add;
$totalquery="select count(*) as total from {$dbtbpre}ecms_".$tbname.$add;
$num=$empire->gettotal($totalquery);//取得總條數
$query=$query." order by id desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page2($num,$line,$page_line,$start,$page,$search);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>選擇</title>
<link href="edit.css" rel="stylesheet" type="text/css">
<link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function ChangeFieldVal(val)
{
opener.document.<?=$form?>.<?=$field?>.value=val;
window.close();
}
</script>
</head>
<body>
<form name="form1" method="get" action="ChangeField.php">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td width="70%"><div align="center">搜索：
<input name="keyboard" type="text" value="<?=$keyboard?>">
<select name="show">
<?=$searchoption?>
</select>
<input type="submit" name="Submit" value="搜索">
<input type=hidden name="form" value="<?=$form?>">
<input type=hidden name="field" value="<?=$field?>">
<input name="tid" type="hidden" id="tid" value="<?=$tid?>">
<input name="tbname" type="hidden" value="<?=$tbname?>">
<input name="viewf" type="hidden" id="viewf" value="<?=$viewf?>">
<input name="changef" type="hidden" id="changef" value="<?=$changef?>">
<input name="changeline" type="hidden" value="<?=$changeline?>">
</div></td>
<td width="30%">
<span id="showaddclassnav"></span>
<input type="button" name="Submit" value="增加信息" onclick="if(document.form1.addclassid.value!=0){window.open('../AddNews.php?enews=AddNews&classid='+document.form1.addclassid.value,'','');}else{alert('請選擇要增加信息的欄目');document.form1.addclassid.focus();}">
</td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr>
<td height="25" bgcolor="#FFFFFF"> <div align="center">
<?php
//輸出
$i=0;
$class_text="";
while($r=$empire->fetch($sql))
{
$i++;
if(($i-1)%$changeline==0||$i==1)
{
$class_text.="<tr>";
}
$class_text.="<td align=center height=25><a href='#ecms' onclick=\"ChangeFieldVal('".htmlspecialchars(stripSlashes($r[$changef]))."');\" title='選擇'>".stripSlashes($r[$viewf])."</a></td>";
//分割
if($i%$changeline==0)
{
$class_text.="</tr>";
}
}
if($i<>0)
{
$table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
$ys=$changeline-$i%$changeline;
$p=0;
for($j=0;$j<$ys&&$ys!=$changeline;$j++)
{
$p=1;
$class_text.="<td></td>";
}
if($p==1)
{
$class_text.="</tr>";
}
}
$text=$table.$class_text.$table1;
echo"$text";
?>
</div></td>
</tr>
<tr>
<td height="25" bgcolor="#FFFFFF" align=center>
<?=$returnpage?>
</td>
</tr>
</table>
<div align="center"> <br>
[<a href="#empirecms" onclick="window.close();">關閉</a>]</div>
<IFRAME frameBorder="0" id="showclassnav" name="showclassnav" scrolling="no" src="../ShowClassNav.php?ecms=7" style="HEIGHT:0;VISIBILITY:inherit;WIDTH:0;Z-INDEX:1"></IFRAME>
</body>
</html>
<?php
db_close();
$empire=null;
?>